How to: Number all pages except the first page of report.
Solution:
In Report Design view, select the 'Insert' menu and select 'Page Number...'. Clear the 'Show Number on First Page' check box in
1) If the Database window is not activated, activate the Database window.
2) Click the 'Reports' tab from the Database window.
Reports tab
3) Click 'Design'. (The report appears in Design view.)
4) Select the 'Insert' menu and select 'Page Number...'. (The Page Numbers dialog box appears.)
5) Clear the 'Show Number on First Page' check box.
Clear the Show Number on First Page check box
6) Click 'OK'. (In Report Design view, a text box with a formula stating =IIf([Page]>1,''Page '' & [Page],'''') appears.)
NOTE 1: The page numbers, other than the first page number, can ONLY be viewed in 'Layout Preview' or 'Print Preview'.